Workday HR System API - Implementation Template

Mapping: Location

WorkdayResponseData TypeDescription
/Location_Data/Contact_Data/Address_Data(@Effective_Date) Note: If Inactive is set to true, Check for any date time translationscloseDateDATEDate the location closed or went out of service
/Location_Data/Location_NamedescriptionTEXT(255)A brief description of the location
If upper(/Location_Data/Location_Usage_Reference/ID(@type='Location_Usage_ID)='MOBILE' then true else false. Note: This type of location usage does not exist in workday test tenant. Externalize the parameter - Location_Usage_ID and MOBILE as values may differ from customer to customerisMobileCHECKBOXIndicates whether the location moves. For example, a truck or tool box.
LatitudeLongitudeGEOLOCATIONThe geographic location
LatitudeLatitudeGEOLOCATIONThe geographic location
/Location_Data/Location_Usage_Reference/ID(@type='Location_Usage_ID) Note: Externalize the parameter - Location_Usage_ID as it may differ from customer to customer. (May use locationmappings.csv for mapping conversion from Workday to Salesforce for Location Type)locationTypePICKLIST"Work location type - Building (default), Warehouse, Site, Plant, Store, Campus, Floor, Space
/Location_Data/Location_IDlocationNameTEXT (NAME)Location_ID in Workday
/Location_Data/Contact_Data/Address_Data(@Effective_Date) Note: If Inactive is set to falseopenDateDATEOpen day of the Location
Note: In order to achieve hierarchical relationship within a location object. We have to process Workday Data in two steps to migrate it successfully to Salesforce. Step-1: We have to do a flat load of location data into salesforce without parent location. And also, store LocationId and its Superior_Location_Reference/ID (@type=Location_ID) into Object Store for all retrieved records of a page. Step2: Fetch Object Store for the batch of locations and get Salesforce Ids of Superior Location Reference IDs and update the locations object with parent location. See Employee Migration for a referenceparentLocationIdLOOKUP(Location__c)For building the hierarchical relationship within a location object
Note: There is a Master-Child Relationship between Address and Location Objects in SFDCVisitorAddressIdLOOKUP(Address__c)Master-Child Relationship between Address and Location Objects in SFDC
TypeTemplate
OrganizationMuleSoft
Published by
MuleSoft Solutions
Published onApr 16, 2021
Asset overview

Asset versions for 1.0.x

Asset versions
VersionActions
1.0.1
1.0.0